Used to constrain the considered lock granularities for an index 用于约束经过考虑的索引锁粒度。
You can choose to change the locking granularity for some operations 您可以选择更改某些操作的锁定粒度。
Lock granularity and hierarchies 锁粒度和层次结构
Index locking granularity 索引锁定粒度
For more information about configuring the locking granularity for an index , see 有关为索引配置锁定粒度的详细信息,请参阅
Use caution , because changing locking granularity can have adverse effects on concurrency 请慎用此操作,因为更改锁定粒度可能对并发性有负面影响。
The database engine can dynamically choose the level of lock granularity based on the optimizer s estimate of the number of rows a transact - sql statement will reference 数据库引擎可以根据优化器估计的transact - sql语句可能引用的行数,动态地选择锁粒度级别。